Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 546279 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 87775 |
| Duplicate rows (%) | 16.1% |
| Total size in memory | 125.0 MiB |
| Average record size in memory | 240.0 B |
Variable types
| Numeric | 19 |
|---|---|
| Categorical | 11 |
| Dataset has 87775 (16.1%) duplicate rows | Duplicates |
days_from_first_active_until_booking is highly correlated with days_from_account_created_until_first_booking | High correlation |
days_from_account_created_until_first_booking is highly correlated with days_from_first_active_until_booking | High correlation |
year_first_active is highly correlated with year_first_booking and 1 other fields | High correlation |
month_first_active is highly correlated with week_of_year_first_active and 4 other fields | High correlation |
day_first_active is highly correlated with day_account_created | High correlation |
day_of_week_first_active is highly correlated with day_of_week_account_created | High correlation |
week_of_year_first_active is highly correlated with month_first_active and 4 other fields | High correlation |
year_first_booking is highly correlated with year_first_active and 1 other fields | High correlation |
month_first_booking is highly correlated with month_first_active and 4 other fields | High correlation |
week_of_year_first_booking is highly correlated with month_first_active and 4 other fields | High correlation |
year_account_created is highly correlated with year_first_active and 1 other fields | High correlation |
month_account_created is highly correlated with month_first_active and 4 other fields | High correlation |
day_account_created is highly correlated with day_first_active | High correlation |
day_of_week_account_created is highly correlated with day_of_week_first_active | High correlation |
week_of_year_account_created is highly correlated with month_first_active and 4 other fields | High correlation |
days_from_first_active_until_booking is highly correlated with days_from_account_created_until_first_booking and 1 other fields | High correlation |
days_from_account_created_until_first_booking is highly correlated with days_from_first_active_until_booking and 1 other fields | High correlation |
year_first_active is highly correlated with year_first_booking and 1 other fields | High correlation |
month_first_active is highly correlated with week_of_year_first_active and 4 other fields | High correlation |
day_first_active is highly correlated with day_account_created | High correlation |
day_of_week_first_active is highly correlated with day_of_week_account_created | High correlation |
week_of_year_first_active is highly correlated with month_first_active and 4 other fields | High correlation |
year_first_booking is highly correlated with days_from_first_active_until_booking and 3 other fields | High correlation |
month_first_booking is highly correlated with month_first_active and 4 other fields | High correlation |
week_of_year_first_booking is highly correlated with month_first_active and 4 other fields | High correlation |
year_account_created is highly correlated with year_first_active and 1 other fields | High correlation |
month_account_created is highly correlated with month_first_active and 4 other fields | High correlation |
day_account_created is highly correlated with day_first_active | High correlation |
day_of_week_account_created is highly correlated with day_of_week_first_active | High correlation |
week_of_year_account_created is highly correlated with month_first_active and 4 other fields | High correlation |
days_from_first_active_until_booking is highly correlated with days_from_account_created_until_first_booking | High correlation |
days_from_account_created_until_first_booking is highly correlated with days_from_first_active_until_booking | High correlation |
year_first_active is highly correlated with year_first_booking and 1 other fields | High correlation |
month_first_active is highly correlated with week_of_year_first_active and 4 other fields | High correlation |
day_first_active is highly correlated with day_account_created | High correlation |
day_of_week_first_active is highly correlated with day_of_week_account_created | High correlation |
week_of_year_first_active is highly correlated with month_first_active and 4 other fields | High correlation |
year_first_booking is highly correlated with year_first_active and 1 other fields | High correlation |
month_first_booking is highly correlated with month_first_active and 4 other fields | High correlation |
week_of_year_first_booking is highly correlated with month_first_active and 4 other fields | High correlation |
year_account_created is highly correlated with year_first_active and 1 other fields | High correlation |
month_account_created is highly correlated with month_first_active and 4 other fields | High correlation |
day_account_created is highly correlated with day_first_active | High correlation |
day_of_week_account_created is highly correlated with day_of_week_first_active | High correlation |
week_of_year_account_created is highly correlated with month_first_active and 4 other fields | High correlation |
affiliate_provider is highly correlated with affiliate_channel | High correlation |
first_browser is highly correlated with first_device_type | High correlation |
signup_app is highly correlated with first_device_type | High correlation |
affiliate_channel is highly correlated with affiliate_provider | High correlation |
first_device_type is highly correlated with first_browser and 1 other fields | High correlation |
signup_flow is highly correlated with affiliate_channel and 3 other fields | High correlation |
days_from_first_active_until_booking is highly correlated with days_from_account_created_until_first_booking and 5 other fields | High correlation |
days_from_account_created_until_first_booking is highly correlated with days_from_first_active_until_booking and 7 other fields | High correlation |
year_first_active is highly correlated with days_from_account_created_until_first_booking and 6 other fields | High correlation |
month_first_active is highly correlated with year_first_active and 6 other fields | High correlation |
day_first_active is highly correlated with day_first_booking and 1 other fields | High correlation |
day_of_week_first_active is highly correlated with day_of_week_account_created | High correlation |
week_of_year_first_active is highly correlated with year_first_active and 6 other fields | High correlation |
year_first_booking is highly correlated with days_from_first_active_until_booking and 7 other fields | High correlation |
month_first_booking is highly correlated with days_from_first_active_until_booking and 7 other fields | High correlation |
day_first_booking is highly correlated with days_from_first_active_until_booking and 6 other fields | High correlation |
week_of_year_first_booking is highly correlated with days_from_first_active_until_booking and 9 other fields | High correlation |
year_account_created is highly correlated with days_from_account_created_until_first_booking and 6 other fields | High correlation |
month_account_created is highly correlated with year_first_active and 6 other fields | High correlation |
day_account_created is highly correlated with day_first_active and 1 other fields | High correlation |
day_of_week_account_created is highly correlated with day_of_week_first_active | High correlation |
week_of_year_account_created is highly correlated with year_first_active and 6 other fields | High correlation |
affiliate_channel is highly correlated with signup_flow and 3 other fields | High correlation |
affiliate_provider is highly correlated with signup_flow and 2 other fields | High correlation |
first_affiliate_tracked is highly correlated with affiliate_channel and 1 other fields | High correlation |
signup_app is highly correlated with signup_flow and 3 other fields | High correlation |
first_device_type is highly correlated with signup_app and 1 other fields | High correlation |
first_browser is highly correlated with signup_flow and 2 other fields | High correlation |
country_destination is highly correlated with days_from_first_active_until_booking and 4 other fields | High correlation |
days_from_first_active_until_account_created is highly skewed (γ1 = 68.1409591) | Skewed |
signup_flow has 434571 (79.6%) zeros | Zeros |
days_from_first_active_until_booking has 120474 (22.1%) zeros | Zeros |
days_from_first_active_until_account_created has 545277 (99.8%) zeros | Zeros |
days_from_account_created_until_first_booking has 120411 (22.0%) zeros | Zeros |
day_of_week_first_active has 85482 (15.6%) zeros | Zeros |
day_of_week_first_booking has 122976 (22.5%) zeros | Zeros |
day_of_week_account_created has 85435 (15.6%) zeros | Zeros |
Reproduction
| Analysis started | 2021-10-23 04:53:08.152220 |
|---|---|
| Analysis finished | 2021-10-23 04:55:12.571403 |
| Duration | 2 minutes and 4.42 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
age
Real number (ℝ≥0)
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.78003548 |
| Minimum | 16 |
|---|---|
| Maximum | 115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 16 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 28 |
| median | 33 |
| Q3 | 41 |
| 95-th percentile | 61 |
| Maximum | 115 |
| Range | 99 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 13.19491544 |
|---|---|
| Coefficient of variation (CV) | 0.3587521129 |
| Kurtosis | 6.785259131 |
| Mean | 36.78003548 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.111932589 |
| Sum | 20092161 |
| Variance | 174.1057934 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31 | 29815 | 5.5% |
| 30 | 29770 | 5.4% |
| 29 | 28661 | 5.2% |
| 32 | 28337 | 5.2% |
| 28 | 26815 | 4.9% |
| 33 | 26116 | 4.8% |
| 27 | 24152 | 4.4% |
| 34 | 23507 | 4.3% |
| 35 | 21945 | 4.0% |
| 26 | 21221 | 3.9% |
| Other values (89) | 285940 |
| Value | Count | Frequency (%) |
| 16 | 26 | < 0.1% |
| 17 | 74 | < 0.1% |
| 18 | 1670 | 0.3% |
| 19 | 3686 | 0.7% |
| 20 | 2771 | 0.5% |
| 21 | 4847 | 0.9% |
| 22 | 8493 | |
| 23 | 11818 | |
| 24 | 14816 | |
| 25 | 18788 |
| Value | Count | Frequency (%) |
| 115 | 12 | < 0.1% |
| 113 | 4 | < 0.1% |
| 112 | 1 | < 0.1% |
| 111 | 2 | < 0.1% |
| 110 | 191 | < 0.1% |
| 109 | 97 | < 0.1% |
| 108 | 83 | < 0.1% |
| 107 | 83 | < 0.1% |
| 106 | 71 | < 0.1% |
| 105 | 4099 |
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.737092218 |
| Minimum | 0 |
|---|---|
| Maximum | 25 |
| Zeros | 434571 |
| Zeros (%) | 79.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 14 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.311753542 |
|---|---|
| Coefficient of variation (CV) | 3.057841999 |
| Kurtosis | 11.34789856 |
| Mean | 1.737092218 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.506835154 |
| Sum | 948937 |
| Variance | 28.21472569 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 434571 | |
| 1 | 27888 | 5.1% |
| 2 | 22776 | 4.2% |
| 25 | 11426 | 2.1% |
| 3 | 9877 | 1.8% |
| 12 | 8243 | 1.5% |
| 24 | 6559 | 1.2% |
| 23 | 2831 | 0.5% |
| 5 | 2086 | 0.4% |
| 6 | 2005 | 0.4% |
| Other values (16) | 18017 | 3.3% |
| Value | Count | Frequency (%) |
| 0 | 434571 | |
| 1 | 27888 | 5.1% |
| 2 | 22776 | 4.2% |
| 3 | 9877 | 1.8% |
| 4 | 1984 | 0.4% |
| 5 | 2086 | 0.4% |
| 6 | 2005 | 0.4% |
| 7 | 1799 | 0.3% |
| 8 | 1819 | 0.3% |
| 9 | 1621 | 0.3% |
| Value | Count | Frequency (%) |
| 25 | 11426 | |
| 24 | 6559 | |
| 23 | 2831 | 0.5% |
| 22 | 796 | 0.1% |
| 21 | 1046 | 0.2% |
| 20 | 655 | 0.1% |
| 19 | 716 | 0.1% |
| 18 | 665 | 0.1% |
| 17 | 703 | 0.1% |
| 16 | 706 | 0.1% |
days_from_first_active_until_booking
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 1853 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.4462738 |
| Minimum | 0 |
|---|---|
| Maximum | 2228 |
| Zeros | 120474 |
| Zeros (%) | 22.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 6 |
| Q3 | 105 |
| 95-th percentile | 675 |
| Maximum | 2228 |
| Range | 2228 |
| Interquartile range (IQR) | 104 |
Descriptive statistics
| Standard deviation | 241.585994 |
|---|---|
| Coefficient of variation (CV) | 2.074656286 |
| Kurtosis | 9.684070986 |
| Mean | 116.4462738 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.960146322 |
| Sum | 63612154 |
| Variance | 58363.79247 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 120474 | |
| 1 | 69034 | 12.6% |
| 2 | 32199 | 5.9% |
| 3 | 20580 | 3.8% |
| 4 | 15089 | 2.8% |
| 5 | 11521 | 2.1% |
| 6 | 10281 | 1.9% |
| 7 | 8860 | 1.6% |
| 8 | 7636 | 1.4% |
| 9 | 6039 | 1.1% |
| Other values (1843) | 244566 |
| Value | Count | Frequency (%) |
| 0 | 120474 | |
| 1 | 69034 | |
| 2 | 32199 | 5.9% |
| 3 | 20580 | 3.8% |
| 4 | 15089 | 2.8% |
| 5 | 11521 | 2.1% |
| 6 | 10281 | 1.9% |
| 7 | 8860 | 1.6% |
| 8 | 7636 | 1.4% |
| 9 | 6039 | 1.1% |
| Value | Count | Frequency (%) |
| 2228 | 1 | |
| 2001 | 2 | |
| 1999 | 1 | |
| 1995 | 1 | |
| 1992 | 1 | |
| 1991 | 2 | |
| 1990 | 2 | |
| 1980 | 1 | |
| 1979 | 1 | |
| 1977 | 1 |
| Distinct | 327 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.226173805 |
| Minimum | 0 |
|---|---|
| Maximum | 1456 |
| Zeros | 545277 |
| Zeros (%) | 99.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1456 |
| Range | 1456 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 10.19124704 |
|---|---|
| Coefficient of variation (CV) | 45.0593606 |
| Kurtosis | 5805.244583 |
| Mean | 0.226173805 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 68.1409591 |
| Sum | 123554 |
| Variance | 103.8615162 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 545277 | |
| 2 | 103 | < 0.1% |
| 1 | 91 | < 0.1% |
| 3 | 67 | < 0.1% |
| 4 | 61 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 14 | < 0.1% |
| 13 | 12 | < 0.1% |
| 29 | 10 | < 0.1% |
| 10 | 9 | < 0.1% |
| Other values (317) | 620 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 545277 | |
| 1 | 91 | < 0.1% |
| 2 | 103 | < 0.1% |
| 3 | 67 | < 0.1% |
| 4 | 61 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 1456 | 1 | |
| 1369 | 1 | |
| 1361 | 1 | |
| 1148 | 1 | |
| 1036 | 1 | |
| 1011 | 1 | |
| 1006 | 1 | |
| 991 | 1 | |
| 984 | 1 | |
| 968 | 1 |
days_from_account_created_until_first_booking
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 1971 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.2196222 |
| Minimum | -349 |
|---|---|
| Maximum | 2001 |
| Zeros | 120411 |
| Zeros (%) | 22.0% |
| Negative | 232 |
| Negative (%) | < 0.1% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | -349 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 6 |
| Q3 | 104 |
| 95-th percentile | 674 |
| Maximum | 2001 |
| Range | 2350 |
| Interquartile range (IQR) | 103 |
Descriptive statistics
| Standard deviation | 241.3262741 |
|---|---|
| Coefficient of variation (CV) | 2.07646755 |
| Kurtosis | 9.698711254 |
| Mean | 116.2196222 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.962090965 |
| Sum | 63488339 |
| Variance | 58238.37059 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 120411 | |
| 1 | 68991 | 12.6% |
| 2 | 32181 | 5.9% |
| 3 | 20569 | 3.8% |
| 4 | 15077 | 2.8% |
| 5 | 11526 | 2.1% |
| 6 | 10289 | 1.9% |
| 7 | 8861 | 1.6% |
| 8 | 7640 | 1.4% |
| 9 | 6039 | 1.1% |
| Other values (1961) | 244695 |
| Value | Count | Frequency (%) |
| -349 | 1 | |
| -347 | 1 | |
| -338 | 1 | |
| -308 | 1 | |
| -298 | 1 | |
| -295 | 1 | |
| -288 | 1 | |
| -273 | 1 | |
| -269 | 1 | |
| -261 | 1 |
| Value | Count | Frequency (%) |
| 2001 | 2 | |
| 1999 | 1 | |
| 1995 | 1 | |
| 1992 | 1 | |
| 1991 | 2 | |
| 1990 | 2 | |
| 1980 | 1 | |
| 1979 | 1 | |
| 1977 | 1 | |
| 1976 | 1 |
year_first_active
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.696038 |
| Minimum | 2009 |
|---|---|
| Maximum | 2014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2011 |
| Q1 | 2012 |
| median | 2013 |
| Q3 | 2013 |
| 95-th percentile | 2014 |
| Maximum | 2014 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9287412643 |
|---|---|
| Coefficient of variation (CV) | 0.0004614413934 |
| Kurtosis | -0.3225380112 |
| Mean | 2012.696038 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.3714002799 |
| Sum | 1099493579 |
| Variance | 0.8625603361 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 220902 | |
| 2012 | 159773 | |
| 2014 | 110344 | |
| 2011 | 49170 | 9.0% |
| 2010 | 6081 | 1.1% |
| 2009 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 2009 | 9 | < 0.1% |
| 2010 | 6081 | 1.1% |
| 2011 | 49170 | 9.0% |
| 2012 | 159773 | |
| 2013 | 220902 | |
| 2014 | 110344 |
| Value | Count | Frequency (%) |
| 2014 | 110344 | |
| 2013 | 220902 | |
| 2012 | 159773 | |
| 2011 | 49170 | 9.0% |
| 2010 | 6081 | 1.1% |
| 2009 | 9 | < 0.1% |
month_first_active
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.806186948 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.064040489 |
|---|---|
| Coefficient of variation (CV) | 0.5277199161 |
| Kurtosis | -0.8653276745 |
| Mean | 5.806186948 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.2761994348 |
| Sum | 3171798 |
| Variance | 9.38834412 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 74458 | |
| 6 | 70701 | |
| 4 | 61420 | |
| 3 | 51173 | |
| 2 | 45375 | |
| 8 | 43397 | |
| 1 | 43202 | |
| 9 | 40490 | |
| 7 | 33307 | |
| 10 | 32058 | |
| Other values (2) | 50698 |
| Value | Count | Frequency (%) |
| 1 | 43202 | |
| 2 | 45375 | |
| 3 | 51173 | |
| 4 | 61420 | |
| 5 | 74458 | |
| 6 | 70701 | |
| 7 | 33307 | |
| 8 | 43397 | |
| 9 | 40490 | |
| 10 | 32058 |
| Value | Count | Frequency (%) |
| 12 | 19158 | 3.5% |
| 11 | 31540 | |
| 10 | 32058 | |
| 9 | 40490 | |
| 8 | 43397 | |
| 7 | 33307 | |
| 6 | 70701 | |
| 5 | 74458 | |
| 4 | 61420 | |
| 3 | 51173 |
day_first_active
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.51226388 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.42517705 |
|---|---|
| Coefficient of variation (CV) | 0.5431300754 |
| Kurtosis | -1.179430597 |
| Mean | 15.51226388 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.0007476385669 |
| Sum | 8474024 |
| Variance | 70.98360832 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 20006 | 3.7% |
| 22 | 19954 | 3.7% |
| 23 | 19672 | 3.6% |
| 27 | 19473 | 3.6% |
| 13 | 19391 | 3.5% |
| 16 | 19358 | 3.5% |
| 3 | 19248 | 3.5% |
| 15 | 19069 | 3.5% |
| 10 | 18974 | 3.5% |
| 21 | 18879 | 3.5% |
| Other values (21) | 352255 |
| Value | Count | Frequency (%) |
| 1 | 12795 | |
| 2 | 16126 | |
| 3 | 19248 | |
| 4 | 18659 | |
| 5 | 18667 | |
| 6 | 18398 | |
| 7 | 18646 | |
| 8 | 18542 | |
| 9 | 18857 | |
| 10 | 18974 |
| Value | Count | Frequency (%) |
| 31 | 2843 | 0.5% |
| 30 | 11313 | |
| 29 | 14627 | |
| 28 | 17372 | |
| 27 | 19473 | |
| 26 | 18169 | |
| 25 | 18742 | |
| 24 | 20006 | |
| 23 | 19672 | |
| 22 | 19954 |
day_of_week_first_active
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.44213671 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 85482 |
| Zeros (%) | 15.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.732002571 |
|---|---|
| Coefficient of variation (CV) | 0.7092160581 |
| Kurtosis | -0.9209470515 |
| Mean | 2.44213671 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.2732539292 |
| Sum | 1334088 |
| Variance | 2.999832906 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 105352 | |
| 1 | 103305 | |
| 3 | 93280 | |
| 0 | 85482 | |
| 4 | 77853 | |
| 5 | 57215 | |
| 6 | 23792 | 4.4% |
| Value | Count | Frequency (%) |
| 0 | 85482 | |
| 1 | 103305 | |
| 2 | 105352 | |
| 3 | 93280 | |
| 4 | 77853 | |
| 5 | 57215 | |
| 6 | 23792 | 4.4% |
| Value | Count | Frequency (%) |
| 6 | 23792 | 4.4% |
| 5 | 57215 | |
| 4 | 77853 | |
| 3 | 93280 | |
| 2 | 105352 | |
| 1 | 103305 | |
| 0 | 85482 |
week_of_year_first_active
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.02255807 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 14 |
| median | 23 |
| Q3 | 34 |
| 95-th percentile | 48 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 13.29538283 |
|---|---|
| Coefficient of variation (CV) | 0.5534540823 |
| Kurtosis | -0.8708825582 |
| Mean | 24.02255807 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.2751285319 |
| Sum | 13123019 |
| Variance | 176.7672046 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23 | 18592 | 3.4% |
| 21 | 17336 | 3.2% |
| 25 | 17012 | 3.1% |
| 19 | 16968 | 3.1% |
| 20 | 16961 | 3.1% |
| 24 | 16923 | 3.1% |
| 26 | 16802 | 3.1% |
| 18 | 15515 | 2.8% |
| 22 | 15352 | 2.8% |
| 17 | 14939 | 2.7% |
| Other values (43) | 379879 |
| Value | Count | Frequency (%) |
| 1 | 5764 | |
| 2 | 6395 | |
| 3 | 9919 | |
| 4 | 10171 | |
| 5 | 9358 | |
| 6 | 11323 | |
| 7 | 11283 | |
| 8 | 11470 | |
| 9 | 11266 | |
| 10 | 11789 |
| Value | Count | Frequency (%) |
| 53 | 2 | < 0.1% |
| 52 | 3262 | |
| 51 | 5131 | |
| 50 | 6159 | |
| 49 | 6992 | |
| 48 | 6224 | |
| 47 | 7396 | |
| 46 | 8149 | |
| 45 | 8008 | |
| 44 | 6755 |
year_first_booking
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.005448 |
| Minimum | 2010 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 2011 |
| Q1 | 2012 |
| median | 2013 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.115803619 |
|---|---|
| Coefficient of variation (CV) | 0.0005542973666 |
| Kurtosis | -0.3914133732 |
| Mean | 2013.005448 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.002770402015 |
| Sum | 1099662603 |
| Variance | 1.245017715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 199068 | |
| 2012 | 134766 | |
| 2014 | 109683 | |
| 2015 | 59628 | 10.9% |
| 2011 | 38205 | 7.0% |
| 2010 | 4929 | 0.9% |
| Value | Count | Frequency (%) |
| 2010 | 4929 | 0.9% |
| 2011 | 38205 | 7.0% |
| 2012 | 134766 | |
| 2013 | 199068 | |
| 2014 | 109683 | |
| 2015 | 59628 | 10.9% |
| Value | Count | Frequency (%) |
| 2015 | 59628 | 10.9% |
| 2014 | 109683 | |
| 2013 | 199068 | |
| 2012 | 134766 | |
| 2011 | 38205 | 7.0% |
| 2010 | 4929 | 0.9% |
month_first_booking
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.896624252 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.78863546 |
|---|---|
| Coefficient of variation (CV) | 0.4729206646 |
| Kurtosis | -0.5811415308 |
| Mean | 5.896624252 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.2078363938 |
| Sum | 3221202 |
| Variance | 7.776487731 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 122412 | |
| 5 | 66871 | |
| 4 | 51430 | |
| 3 | 44936 | 8.2% |
| 8 | 42984 | 7.9% |
| 7 | 39742 | 7.3% |
| 2 | 39337 | 7.2% |
| 9 | 37727 | 6.9% |
| 1 | 32093 | 5.9% |
| 10 | 29770 | 5.4% |
| Other values (2) | 38977 | 7.1% |
| Value | Count | Frequency (%) |
| 1 | 32093 | 5.9% |
| 2 | 39337 | 7.2% |
| 3 | 44936 | 8.2% |
| 4 | 51430 | |
| 5 | 66871 | |
| 6 | 122412 | |
| 7 | 39742 | 7.3% |
| 8 | 42984 | 7.9% |
| 9 | 37727 | 6.9% |
| 10 | 29770 | 5.4% |
| Value | Count | Frequency (%) |
| 12 | 13024 | 2.4% |
| 11 | 25953 | 4.8% |
| 10 | 29770 | 5.4% |
| 9 | 37727 | 6.9% |
| 8 | 42984 | 7.9% |
| 7 | 39742 | 7.3% |
| 6 | 122412 | |
| 5 | 66871 | |
| 4 | 51430 | |
| 3 | 44936 | 8.2% |
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.58056964 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 9 |
| median | 17 |
| Q3 | 25 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.890933776 |
|---|---|
| Coefficient of variation (CV) | 0.5362260749 |
| Kurtosis | -1.250846033 |
| Mean | 16.58056964 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.0815341159 |
| Sum | 9057617 |
| Variance | 79.0487034 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29 | 66746 | 12.2% |
| 15 | 18369 | 3.4% |
| 16 | 18127 | 3.3% |
| 5 | 18061 | 3.3% |
| 17 | 17815 | 3.3% |
| 23 | 17738 | 3.2% |
| 11 | 17555 | 3.2% |
| 4 | 17546 | 3.2% |
| 9 | 17401 | 3.2% |
| 13 | 17363 | 3.2% |
| Other values (21) | 319558 |
| Value | Count | Frequency (%) |
| 1 | 12871 | |
| 2 | 14764 | |
| 3 | 16673 | |
| 4 | 17546 | |
| 5 | 18061 | |
| 6 | 16794 | |
| 7 | 16317 | |
| 8 | 16438 | |
| 9 | 17401 | |
| 10 | 16944 |
| Value | Count | Frequency (%) |
| 31 | 2028 | 0.4% |
| 30 | 7800 | 1.4% |
| 29 | 66746 | |
| 28 | 14067 | 2.6% |
| 27 | 14972 | 2.7% |
| 26 | 15497 | 2.8% |
| 25 | 17109 | 3.1% |
| 24 | 17242 | 3.2% |
| 23 | 17738 | 3.2% |
| 22 | 17196 | 3.1% |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.198726292 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 122976 |
| Zeros (%) | 22.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.740718929 |
|---|---|
| Coefficient of variation (CV) | 0.7916942348 |
| Kurtosis | -0.9350392808 |
| Mean | 2.198726292 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.3442726796 |
| Sum | 1201118 |
| Variance | 3.030102391 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 122976 | |
| 2 | 99818 | |
| 1 | 95110 | |
| 3 | 89558 | |
| 4 | 72818 | |
| 5 | 49568 | |
| 6 | 16431 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 122976 | |
| 1 | 95110 | |
| 2 | 99818 | |
| 3 | 89558 | |
| 4 | 72818 | |
| 5 | 49568 | |
| 6 | 16431 | 3.0% |
| Value | Count | Frequency (%) |
| 6 | 16431 | 3.0% |
| 5 | 49568 | |
| 4 | 72818 | |
| 3 | 89558 | |
| 2 | 99818 | |
| 1 | 95110 | |
| 0 | 122976 |
week_of_year_first_booking
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.66208476 |
| Minimum | 1 |
|---|---|
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 25 |
| Q3 | 33 |
| 95-th percentile | 46 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 12.15744672 |
|---|---|
| Coefficient of variation (CV) | 0.4929610305 |
| Kurtosis | -0.6199561973 |
| Mean | 24.66208476 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.1555659313 |
| Sum | 13472379 |
| Variance | 147.8035107 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 27 | 66130 | 12.1% |
| 24 | 17404 | 3.2% |
| 23 | 16869 | 3.1% |
| 21 | 16335 | 3.0% |
| 25 | 15682 | 2.9% |
| 26 | 15175 | 2.8% |
| 20 | 14801 | 2.7% |
| 19 | 14599 | 2.7% |
| 22 | 13686 | 2.5% |
| 18 | 13617 | 2.5% |
| Other values (42) | 341981 |
| Value | Count | Frequency (%) |
| 1 | 4045 | 0.7% |
| 2 | 4745 | |
| 3 | 7661 | |
| 4 | 7974 | |
| 5 | 7177 | |
| 6 | 9017 | |
| 7 | 9476 | |
| 8 | 10118 | |
| 9 | 9806 | |
| 10 | 10369 |
| Value | Count | Frequency (%) |
| 52 | 1775 | 0.3% |
| 51 | 3854 | |
| 50 | 4770 | |
| 49 | 5604 | |
| 48 | 5099 | |
| 47 | 5790 | |
| 46 | 6480 | |
| 45 | 6863 | |
| 44 | 5632 | |
| 43 | 6086 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| 2013 | |
|---|---|
| 2012 | |
| 2014 | |
| 2011 | |
| 2010 | 6047 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2011 |
|---|---|
| 2nd row | 2010 |
| 3rd row | 2011 |
| 4th row | 2010 |
| 5th row | 2010 |
Common Values
| Value | Count | Frequency (%) |
| 2013 | 220953 | |
| 2012 | 159786 | |
| 2014 | 110385 | |
| 2011 | 49108 | 9.0% |
| 2010 | 6047 | 1.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2013 | 220953 | |
| 2012 | 159786 | |
| 2014 | 110385 | |
| 2011 | 49108 | 9.0% |
| 2010 | 6047 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
month_account_created
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.807395122 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.064773168 |
|---|---|
| Coefficient of variation (CV) | 0.5277362921 |
| Kurtosis | -0.8662793891 |
| Mean | 5.807395122 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.2756048808 |
| Sum | 3172458 |
| Variance | 9.392834574 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 74443 | |
| 6 | 70662 | |
| 4 | 61361 | |
| 3 | 51150 | |
| 2 | 45364 | |
| 8 | 43420 | |
| 1 | 43221 | |
| 9 | 40494 | |
| 7 | 33322 | |
| 10 | 32057 | |
| Other values (2) | 50785 |
| Value | Count | Frequency (%) |
| 1 | 43221 | |
| 2 | 45364 | |
| 3 | 51150 | |
| 4 | 61361 | |
| 5 | 74443 | |
| 6 | 70662 | |
| 7 | 33322 | |
| 8 | 43420 | |
| 9 | 40494 | |
| 10 | 32057 |
| Value | Count | Frequency (%) |
| 12 | 19163 | 3.5% |
| 11 | 31622 | |
| 10 | 32057 | |
| 9 | 40494 | |
| 8 | 43420 | |
| 7 | 33322 | |
| 6 | 70662 | |
| 5 | 74443 | |
| 4 | 61361 | |
| 3 | 51150 |
day_account_created
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.51420428 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.426259432 |
|---|---|
| Coefficient of variation (CV) | 0.5431319119 |
| Kurtosis | -1.179780674 |
| Mean | 15.51420428 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.001108146792 |
| Sum | 8475084 |
| Variance | 71.00184802 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 20025 | 3.7% |
| 22 | 19978 | 3.7% |
| 23 | 19644 | 3.6% |
| 27 | 19491 | 3.6% |
| 16 | 19380 | 3.5% |
| 13 | 19380 | 3.5% |
| 3 | 19254 | 3.5% |
| 15 | 19070 | 3.5% |
| 10 | 18986 | 3.5% |
| 9 | 18876 | 3.5% |
| Other values (21) | 352195 |
| Value | Count | Frequency (%) |
| 1 | 12800 | |
| 2 | 16128 | |
| 3 | 19254 | |
| 4 | 18663 | |
| 5 | 18659 | |
| 6 | 18378 | |
| 7 | 18635 | |
| 8 | 18547 | |
| 9 | 18876 | |
| 10 | 18986 |
| Value | Count | Frequency (%) |
| 31 | 2842 | 0.5% |
| 30 | 11307 | |
| 29 | 14621 | |
| 28 | 17435 | |
| 27 | 19491 | |
| 26 | 18169 | |
| 25 | 18743 | |
| 24 | 20025 | |
| 23 | 19644 | |
| 22 | 19978 |
day_of_week_account_created
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.442533943 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 85435 |
| Zeros (%) | 15.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.732170097 |
|---|---|
| Coefficient of variation (CV) | 0.7091693042 |
| Kurtosis | -0.9214786044 |
| Mean | 2.442533943 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.2732217998 |
| Sum | 1334305 |
| Variance | 3.000413245 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 105409 | |
| 1 | 103329 | |
| 3 | 93136 | |
| 0 | 85435 | |
| 4 | 77903 | |
| 5 | 57264 | |
| 6 | 23803 | 4.4% |
| Value | Count | Frequency (%) |
| 0 | 85435 | |
| 1 | 103329 | |
| 2 | 105409 | |
| 3 | 93136 | |
| 4 | 77903 | |
| 5 | 57264 | |
| 6 | 23803 | 4.4% |
| Value | Count | Frequency (%) |
| 6 | 23803 | 4.4% |
| 5 | 57264 | |
| 4 | 77903 | |
| 3 | 93136 | |
| 2 | 105409 | |
| 1 | 103329 | |
| 0 | 85435 |
week_of_year_account_created
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.02836097 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 14 |
| median | 23 |
| Q3 | 34 |
| 95-th percentile | 48 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 13.29918669 |
|---|---|
| Coefficient of variation (CV) | 0.5534787292 |
| Kurtosis | -0.8720709604 |
| Mean | 24.02836097 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.2745425759 |
| Sum | 13126189 |
| Variance | 176.8683667 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23 | 18589 | 3.4% |
| 21 | 17345 | 3.2% |
| 25 | 17014 | 3.1% |
| 19 | 16951 | 3.1% |
| 20 | 16931 | 3.1% |
| 24 | 16914 | 3.1% |
| 26 | 16794 | 3.1% |
| 18 | 15518 | 2.8% |
| 22 | 15362 | 2.8% |
| 17 | 14928 | 2.7% |
| Other values (43) | 379933 |
| Value | Count | Frequency (%) |
| 1 | 5766 | |
| 2 | 6396 | |
| 3 | 9917 | |
| 4 | 10172 | |
| 5 | 9368 | |
| 6 | 11326 | |
| 7 | 11288 | |
| 8 | 11461 | |
| 9 | 11265 | |
| 10 | 11786 |
| Value | Count | Frequency (%) |
| 53 | 2 | < 0.1% |
| 52 | 3263 | 0.6% |
| 51 | 5132 | |
| 50 | 6160 | |
| 49 | 6994 | |
| 48 | 6226 | |
| 47 | 7460 | |
| 46 | 8165 | |
| 45 | 8016 | |
| 44 | 6757 |
gender
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| FEMALE | |
|---|---|
| MALE | |
| -unknown- | |
| OTHER | 1600 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.667924266 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MALE |
|---|---|
| 2nd row | FEMALE |
| 3rd row | FEMALE |
| 4th row | -unknown- |
| 5th row | FEMALE |
Common Values
| Value | Count | Frequency (%) |
| FEMALE | 243211 | |
| MALE | 216842 | |
| -unknown- | 84626 | 15.5% |
| OTHER | 1600 | 0.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| female | 243211 | |
| male | 216842 | |
| unknown | 84626 | 15.5% |
| other | 1600 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
signup_method
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| basic | |
|---|---|
| 507 |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 6.117577282 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | basic |
| 3rd row | |
| 4th row | basic |
| 5th row | basic |
Common Values
| Value | Count | Frequency (%) |
| basic | 342438 | |
| 203334 | ||
| 507 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| basic | 342438 | |
| 203334 | ||
| 507 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
language
Categorical
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| en | |
|---|---|
| fr | 3510 |
| es | 2500 |
| de | 2362 |
| zh | 1761 |
| Other values (20) | 4803 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | en |
|---|---|
| 2nd row | en |
| 3rd row | en |
| 4th row | en |
| 5th row | en |
Common Values
| Value | Count | Frequency (%) |
| en | 531343 | |
| fr | 3510 | 0.6% |
| es | 2500 | 0.5% |
| de | 2362 | 0.4% |
| zh | 1761 | 0.3% |
| it | 1037 | 0.2% |
| ko | 975 | 0.2% |
| ru | 686 | 0.1% |
| nl | 386 | 0.1% |
| pt | 380 | 0.1% |
| Other values (15) | 1339 | 0.2% |
Length
| Value | Count | Frequency (%) |
| en | 531343 | |
| fr | 3510 | 0.6% |
| es | 2500 | 0.5% |
| de | 2362 | 0.4% |
| zh | 1761 | 0.3% |
| it | 1037 | 0.2% |
| ko | 975 | 0.2% |
| ru | 686 | 0.1% |
| nl | 386 | 0.1% |
| pt | 380 | 0.1% |
| Other values (15) | 1339 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| direct | |
|---|---|
| sem-brand | |
| sem-non-brand | |
| seo | 24159 |
| other | 15986 |
| Other values (3) | 22239 |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 6.806657404 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | seo |
|---|---|
| 2nd row | direct |
| 3rd row | direct |
| 4th row | direct |
| 5th row | other |
Common Values
| Value | Count | Frequency (%) |
| direct | 363423 | |
| sem-brand | 72963 | 13.4% |
| sem-non-brand | 47509 | 8.7% |
| seo | 24159 | 4.4% |
| other | 15986 | 2.9% |
| api | 13862 | 2.5% |
| content | 5657 | 1.0% |
| remarketing | 2720 | 0.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| direct | 363423 | |
| sem-brand | 72963 | 13.4% |
| sem-non-brand | 47509 | 8.7% |
| seo | 24159 | 4.4% |
| other | 15986 | 2.9% |
| api | 13862 | 2.5% |
| content | 5657 | 1.0% |
| remarketing | 2720 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| direct | |
|---|---|
| other | 22322 |
| 6818 | |
| craigslist | 6206 |
| Other values (12) | 11426 |
Length
| Max length | 19 |
|---|---|
| Median length | 6 |
| Mean length | 6.051290641 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | direct |
| 3rd row | direct |
| 4th row | direct |
| 5th row | craigslist |
Common Values
| Value | Count | Frequency (%) |
| direct | 362413 | |
| 137094 | 25.1% | |
| other | 22322 | 4.1% |
| 6818 | 1.2% | |
| craigslist | 6206 | 1.1% |
| bing | 5613 | 1.0% |
| facebook-open-graph | 1716 | 0.3% |
| vast | 1296 | 0.2% |
| padmapper | 967 | 0.2% |
| yahoo | 739 | 0.1% |
| Other values (7) | 1095 | 0.2% |
Length
| Value | Count | Frequency (%) |
| direct | 362413 | |
| 137094 | 25.1% | |
| other | 22322 | 4.1% |
| 6818 | 1.2% | |
| craigslist | 6206 | 1.1% |
| bing | 5613 | 1.0% |
| facebook-open-graph | 1716 | 0.3% |
| vast | 1296 | 0.2% |
| padmapper | 967 | 0.2% |
| yahoo | 739 | 0.1% |
| Other values (7) | 1095 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| untracked | |
|---|---|
| linked | |
| omg | |
| tracked-other | 12357 |
| product | 3842 |
| Other values (2) | 320 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 7.194492192 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | untracked |
|---|---|
| 2nd row | untracked |
| 3rd row | untracked |
| 4th row | untracked |
| 5th row | untracked |
Common Values
| Value | Count | Frequency (%) |
| untracked | 298351 | |
| linked | 120133 | |
| omg | 111276 | 20.4% |
| tracked-other | 12357 | 2.3% |
| product | 3842 | 0.7% |
| marketing | 243 | < 0.1% |
| local ops | 77 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| untracked | 298351 | |
| linked | 120133 | |
| omg | 111276 | 20.4% |
| tracked-other | 12357 | 2.3% |
| product | 3842 | 0.7% |
| marketing | 243 | < 0.1% |
| local | 77 | < 0.1% |
| ops | 77 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Web | |
|---|---|
| iOS | 27946 |
| Moweb | 7662 |
| Android | 5774 |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.070330362 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Web |
|---|---|
| 2nd row | Web |
| 3rd row | Web |
| 4th row | Web |
| 5th row | Web |
Common Values
| Value | Count | Frequency (%) |
| Web | 504897 | |
| iOS | 27946 | 5.1% |
| Moweb | 7662 | 1.4% |
| Android | 5774 | 1.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| web | 504897 | |
| ios | 27946 | 5.1% |
| moweb | 7662 | 1.4% |
| android | 5774 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Mac Desktop | |
|---|---|
| Windows Desktop | |
| iPad | |
| iPhone | |
| Other/Unknown | 5982 |
| Other values (4) | 9281 |
Length
| Max length | 18 |
|---|---|
| Median length | 11 |
| Mean length | 11.66326364 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mac Desktop |
|---|---|
| 2nd row | Windows Desktop |
| 3rd row | Mac Desktop |
| 4th row | Mac Desktop |
| 5th row | Mac Desktop |
Common Values
| Value | Count | Frequency (%) |
| Mac Desktop | 282841 | |
| Windows Desktop | 181356 | |
| iPad | 34821 | 6.4% |
| iPhone | 31998 | 5.9% |
| Other/Unknown | 5982 | 1.1% |
| Desktop (Other) | 3596 | 0.7% |
| Android Phone | 3031 | 0.6% |
| Android Tablet | 2587 | 0.5% |
| SmartPhone (Other) | 67 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| desktop | 467793 | |
| mac | 282841 | |
| windows | 181356 | 17.8% |
| ipad | 34821 | 3.4% |
| iphone | 31998 | 3.1% |
| other/unknown | 5982 | 0.6% |
| android | 5618 | 0.6% |
| other | 3663 | 0.4% |
| phone | 3031 | 0.3% |
| tablet | 2587 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 41 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Chrome | |
|---|---|
| Safari | |
| Firefox | |
| IE | |
| Mobile Safari | |
| Other values (36) |
Length
| Max length | 18 |
|---|---|
| Median length | 6 |
| Mean length | 6.614079985 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Chrome |
|---|---|
| 2nd row | IE |
| 3rd row | Firefox |
| 4th row | Chrome |
| 5th row | Safari |
Common Values
| Value | Count | Frequency (%) |
| Chrome | 191007 | |
| Safari | 133717 | |
| Firefox | 98677 | |
| IE | 44859 | 8.2% |
| Mobile Safari | 42069 | 7.7% |
| -unknown- | 30873 | 5.7% |
| Chrome Mobile | 2131 | 0.4% |
| Android Browser | 1124 | 0.2% |
| Opera | 419 | 0.1% |
| Chromium | 273 | < 0.1% |
| Other values (31) | 1130 | 0.2% |
Length
| Value | Count | Frequency (%) |
| chrome | 193138 | |
| safari | 175786 | |
| firefox | 98716 | |
| ie | 44872 | 7.6% |
| mobile | 44254 | 7.5% |
| unknown | 30873 | 5.2% |
| browser | 1218 | 0.2% |
| android | 1124 | 0.2% |
| opera | 423 | 0.1% |
| chromium | 273 | < 0.1% |
| Other values (33) | 1455 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| NDF | |
|---|---|
| GB | |
| ES | |
| NL | |
| US | |
| Other values (7) |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.346165604 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NDF |
|---|---|
| 2nd row | US |
| 3rd row | other |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| NDF | 54850 | |
| GB | 52688 | |
| ES | 50508 | |
| NL | 47598 | |
| US | 47539 | |
| PT | 47100 | |
| other | 44751 | |
| FR | 43870 | |
| CA | 42542 | |
| IT | 40200 | |
| Other values (2) | 74633 |
Length
| Value | Count | Frequency (%) |
| ndf | 54850 | |
| gb | 52688 | |
| es | 50508 | |
| nl | 47598 | |
| us | 47539 | |
| pt | 47100 | |
| other | 44751 | |
| fr | 43870 | |
| ca | 42542 | |
| it | 40200 | |
| Other values (2) | 74633 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| age | signup_flow | days_from_first_active_until_booking | days_from_first_active_until_account_created | days_from_account_created_until_first_booking | year_first_active | month_first_active | day_first_active | day_of_week_first_active | week_of_year_first_active | year_first_booking | month_first_booking | day_first_booking | day_of_week_first_booking | week_of_year_first_booking | year_account_created | month_account_created | day_account_created | day_of_week_account_created | week_of_year_account_created | gender | signup_method | language | affiliate_channel | affiliate_provider | first_affiliate_tracked | signup_app | first_device_type | first_browser | country_destination | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 38 | 0 | 2228 | 732 | 1496 | 2009 | 5 | 23 | 5 | 21 | 2015 | 6 | 29 | 0 | 27 | 2011 | 5 | 25 | 2 | 21 | MALE | en | seo | untracked | Web | Mac Desktop | Chrome | NDF | ||
| 1 | 56 | 3 | 419 | 476 | -57 | 2009 | 6 | 9 | 1 | 24 | 2010 | 8 | 2 | 0 | 31 | 2010 | 9 | 28 | 1 | 39 | FEMALE | basic | en | direct | direct | untracked | Web | Windows Desktop | IE | US |
| 2 | 42 | 0 | 1043 | 765 | 278 | 2009 | 10 | 31 | 5 | 44 | 2012 | 9 | 8 | 5 | 36 | 2011 | 12 | 5 | 0 | 49 | FEMALE | en | direct | direct | untracked | Web | Mac Desktop | Firefox | other | |
| 3 | 41 | 0 | 72 | 280 | -208 | 2009 | 12 | 8 | 1 | 50 | 2010 | 2 | 18 | 3 | 7 | 2010 | 9 | 14 | 1 | 37 | -unknown- | basic | en | direct | direct | untracked | Web | Mac Desktop | Chrome | US |
| 4 | 46 | 0 | 3 | 0 | 3 | 2010 | 1 | 2 | 5 | 53 | 2010 | 1 | 5 | 1 | 1 | 2010 | 1 | 2 | 5 | 53 | FEMALE | basic | en | other | craigslist | untracked | Web | Mac Desktop | Safari | US |
| 5 | 47 | 0 | 10 | 0 | 10 | 2010 | 1 | 3 | 6 | 53 | 2010 | 1 | 13 | 2 | 2 | 2010 | 1 | 3 | 6 | 53 | FEMALE | basic | en | direct | direct | omg | Web | Mac Desktop | Safari | US |
| 6 | 50 | 0 | 206 | 0 | 206 | 2010 | 1 | 4 | 0 | 1 | 2010 | 7 | 29 | 3 | 30 | 2010 | 1 | 4 | 0 | 1 | FEMALE | basic | en | other | craigslist | untracked | Web | Mac Desktop | Safari | US |
| 7 | 46 | 0 | 0 | 0 | 0 | 2010 | 1 | 4 | 0 | 1 | 2010 | 1 | 4 | 0 | 1 | 2010 | 1 | 4 | 0 | 1 | -unknown- | basic | en | other | craigslist | omg | Web | Mac Desktop | Firefox | US |
| 8 | 36 | 0 | 2 | 0 | 2 | 2010 | 1 | 4 | 0 | 1 | 2010 | 1 | 6 | 2 | 1 | 2010 | 1 | 4 | 0 | 1 | FEMALE | basic | en | other | craigslist | untracked | Web | Mac Desktop | Firefox | US |
| 9 | 47 | 0 | 2001 | 0 | 2001 | 2010 | 1 | 5 | 1 | 1 | 2015 | 6 | 29 | 0 | 27 | 2010 | 1 | 5 | 1 | 1 | FEMALE | basic | en | other | craigslist | untracked | Web | iPhone | -unknown- | NDF |
Last rows
| age | signup_flow | days_from_first_active_until_booking | days_from_first_active_until_account_created | days_from_account_created_until_first_booking | year_first_active | month_first_active | day_first_active | day_of_week_first_active | week_of_year_first_active | year_first_booking | month_first_booking | day_first_booking | day_of_week_first_booking | week_of_year_first_booking | year_account_created | month_account_created | day_account_created | day_of_week_account_created | week_of_year_account_created | gender | signup_method | language | affiliate_channel | affiliate_provider | first_affiliate_tracked | signup_app | first_device_type | first_browser | country_destination | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 546269 | 46 | 0 | 172 | 0 | 172 | 2014 | 1 | 9 | 6 | 5 | 2014 | 7 | 27 | 2 | 30 | 2014 | 1 | 9 | 6 | 5 | MALE | basic | en | direct | direct | untracked | Web | Mac Desktop | Chrome | other |
| 546270 | 25 | 0 | 0 | 0 | 0 | 2013 | 12 | 17 | 1 | 51 | 2013 | 12 | 17 | 1 | 51 | 2013 | 12 | 17 | 1 | 51 | MALE | basic | en | sem-brand | omg | Web | Windows Desktop | Chrome | other | |
| 546271 | 29 | 20 | 73 | 0 | 73 | 2014 | 3 | 4 | 2 | 11 | 2014 | 5 | 16 | 5 | 21 | 2014 | 3 | 4 | 2 | 11 | FEMALE | basic | en | direct | direct | untracked | iOS | Mac Desktop | Chrome | other |
| 546272 | 31 | 0 | 1 | 0 | 1 | 2013 | 11 | 19 | 1 | 47 | 2013 | 11 | 20 | 2 | 47 | 2013 | 11 | 19 | 1 | 47 | FEMALE | basic | en | sem-non-brand | omg | Web | Windows Desktop | Chrome | other | |
| 546273 | 40 | 0 | 1 | 0 | 1 | 2012 | 10 | 1 | 0 | 40 | 2012 | 10 | 2 | 2 | 40 | 2012 | 10 | 1 | 0 | 40 | FEMALE | basic | en | direct | direct | omg | Web | Mac Desktop | Safari | other |
| 546274 | 33 | 0 | 1 | 0 | 1 | 2013 | 3 | 20 | 2 | 12 | 2013 | 3 | 22 | 4 | 12 | 2013 | 3 | 20 | 2 | 12 | FEMALE | basic | en | direct | direct | linked | Web | Mac Desktop | Firefox | other |
| 546275 | 34 | 0 | 52 | 0 | 52 | 2012 | 7 | 7 | 0 | 27 | 2012 | 8 | 29 | 3 | 35 | 2012 | 7 | 7 | 0 | 27 | MALE | en | direct | direct | linked | Web | Windows Desktop | Firefox | other | |
| 546276 | 29 | 0 | 22 | 0 | 22 | 2013 | 5 | 21 | 2 | 21 | 2013 | 6 | 13 | 3 | 24 | 2013 | 5 | 21 | 2 | 21 | -unknown- | basic | en | direct | direct | untracked | Web | Windows Desktop | IE | other |
| 546277 | 28 | 0 | 2 | 0 | 2 | 2014 | 1 | 13 | 0 | 3 | 2014 | 1 | 16 | 3 | 3 | 2014 | 1 | 13 | 0 | 3 | FEMALE | basic | en | direct | direct | linked | Web | Mac Desktop | Safari | other |
| 546278 | 39 | 0 | 1 | 0 | 1 | 2011 | 7 | 22 | 5 | 29 | 2011 | 7 | 23 | 3 | 29 | 2011 | 7 | 22 | 5 | 29 | FEMALE | basic | en | direct | direct | untracked | Web | Windows Desktop | Chrome | other |
Most frequently occurring
| age | signup_flow | days_from_first_active_until_booking | days_from_first_active_until_account_created | days_from_account_created_until_first_booking | year_first_active | month_first_active | day_first_active | day_of_week_first_active | week_of_year_first_active | year_first_booking | month_first_booking | day_first_booking | day_of_week_first_booking | week_of_year_first_booking | year_account_created | month_account_created | day_account_created | day_of_week_account_created | week_of_year_account_created | gender | signup_method | language | affiliate_channel | affiliate_provider | first_affiliate_tracked | signup_app | first_device_type | first_browser | country_destination | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50458 | 35 | 0 | 0 | 0 | 0 | 2013 | 6 | 13 | 5 | 27 | 2013 | 6 | 13 | 5 | 27 | 2013 | 6 | 13 | 5 | 27 | -unknown- | basic | en | direct | direct | untracked | Web | Mac Desktop | Chrome | PT | 89 |
| 32942 | 31 | 0 | 0 | 0 | 0 | 2013 | 6 | 15 | 5 | 24 | 2013 | 6 | 15 | 5 | 24 | 2013 | 6 | 15 | 5 | 24 | FEMALE | en | direct | direct | untracked | Web | Windows Desktop | Chrome | PT | 85 | |
| 42373 | 33 | 0 | 0 | 0 | 0 | 2013 | 6 | 15 | 6 | 24 | 2013 | 6 | 15 | 6 | 24 | 2013 | 6 | 15 | 6 | 24 | -unknown- | basic | en | sem-brand | untracked | Web | Windows Desktop | Chrome | PT | 68 | |
| 37723 | 32 | 0 | 0 | 0 | 0 | 2013 | 6 | 15 | 5 | 24 | 2013 | 6 | 15 | 5 | 24 | 2013 | 6 | 15 | 5 | 24 | -unknown- | basic | en | sem-brand | untracked | Web | Windows Desktop | Chrome | PT | 66 | |
| 27502 | 30 | 0 | 0 | 0 | 0 | 2012 | 8 | 14 | 2 | 33 | 2012 | 8 | 14 | 2 | 33 | 2012 | 8 | 14 | 2 | 33 | FEMALE | en | direct | direct | linked | Web | Mac Desktop | Chrome | PT | 65 | |
| 11205 | 26 | 0 | 0 | 0 | 0 | 2013 | 3 | 4 | 0 | 10 | 2013 | 3 | 5 | 1 | 10 | 2013 | 3 | 4 | 0 | 10 | -unknown- | basic | en | direct | direct | untracked | Web | Mac Desktop | Chrome | PT | 64 |
| 46652 | 34 | 0 | 0 | 0 | 0 | 2013 | 6 | 15 | 6 | 24 | 2013 | 6 | 15 | 6 | 24 | 2013 | 6 | 15 | 6 | 24 | -unknown- | basic | en | direct | direct | linked | Web | Mac Desktop | Firefox | PT | 63 |
| 8217 | 25 | 0 | 0 | 0 | 0 | 2013 | 3 | 5 | 1 | 10 | 2013 | 3 | 6 | 2 | 10 | 2013 | 3 | 5 | 1 | 10 | MALE | en | sem-brand | omg | Web | Windows Desktop | Chrome | PT | 62 | ||
| 43050 | 33 | 0 | 1 | 0 | 1 | 2013 | 10 | 3 | 3 | 40 | 2013 | 10 | 4 | 4 | 40 | 2013 | 10 | 3 | 3 | 40 | MALE | basic | en | direct | direct | untracked | Web | Windows Desktop | Chrome | PT | 62 |
| 53577 | 36 | 0 | 0 | 0 | 0 | 2012 | 6 | 18 | 1 | 24 | 2012 | 6 | 18 | 1 | 24 | 2012 | 6 | 18 | 1 | 24 | FEMALE | en | direct | direct | omg | Web | Mac Desktop | Safari | PT | 60 |